package com.neuedu.yyzx.po;

import com.baomidou.mybatisplus.annotation.*;

import java.io.Serializable;
import lombok.Data;

/**
 *
 * @TableName customerpreference
 */
@TableName(value ="customerpreference")
@Data
public class Customerpreference implements Serializable {
    /**
     * id
     */
    @TableId(value = "pre_id", type = IdType.AUTO)
    private Integer preId;

    /**
     * 客户编号
     */
    @TableField(value = "customer_id")
    private Integer customerId;

    /**
     * 喜好
     */
    @TableField(value = "preferences")
    private String preferences;

    /**
     * 注意事项
     */
    @TableField(value = "attention")
    private String attention;

    /**
     * 备注
     */
    @TableField(value = "remark")
    private String remark;

    /**
     * 逻辑删除标记（0：显示；1：隐藏）
     */
    @TableField(value = "is_deleted")
    @TableLogic
    private Integer isDeleted;

    // ********** 以下是额外加的内容 **********

    // 外键关联 额外插入的字段
    // 会出现的问题：单标增删改查时，会多出 customerName 字段
    // 所以在前面增加exist = false
    // 姓名
    @TableField(exist = false)
    private String customerName;
    // 年龄
    @TableField(exist = false)
    private String customerAge;
    // 性别
    @TableField(exist = false)
    private String customerSex;
    // 楼号
    @TableField(exist = false)
    private String buildingNo;
    // 房间号
    @TableField(exist = false)
    private Integer roomNo;
    // 床号
    @TableField(exist = false)
    private String bedId;
    // 身体状况
    @TableField(exist = false)
    private String psychosomaticState;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}